Visualizing the active registered participants on the particular days

Description

This is the original data set from the company where I am working. As I am working as a Data Analyst intern in an event management industry, most of the time I have to check which participants have been activated their profile till the event date. If the any of the participant did not activate their profile, I confirm my colleagues who are working with the event organisers so that they can send a notification to the participants to activate their profile. As this is the original data set so for security purpose of the company I can't upload the data. But I can tell that I have worked only with the participant id, registration date, registration time, invitation time, participant type, registration state columns.
As I want to visualize the graph for the unique number of active participants according to their registration date and also unique number of participants accorto their invitation date so I have made four functions.


Let's jump to the work!

Functions

Call the functions for the all participants

Call the functions for the different types of participants

Visualization

Conclusion

The main task was to visualize the aggregative curve for the unique oarticipants on the unique date. I have tried to make it work for all the similar data set. We will give the structure of the column name to the developers and tell them to capture the raw data like this and it will work.When the management sector will see the graph before the event, they will be able to check are the participants activating their profile or not, how the rate of activation is growing comparing the invitation date. For example, from the job seeker graph, it can be illustarted that the on 27th October, the highest number of the job seekers (42) have been activated their profile and till October 28, total activated job seekers were 206 where as total 306 invitation had been sent to the job seekers till October 29. May be for some reason, some job seeker did not activate their profile. The reason could be maybe they forgot and did not get the emailor they have lost link for activating it etc. When they will see that activation rate is low,they can tell the event organizer for campaigining their event and send an email to the participants who doesn't activate their profile. If one wants to see only the one kind of participants, she/he can only click the any group of the legend; it will show the graph only for the selected one.


Thank you!